Libris Britannia 4/science library(b).zip/science library(b)/PROGRAMM/DB_CLIPP/1517.ZIP/DB4LESS3.ZIP/SQLDEMO.PRS

Text File | 1989-01-04 | 394b | 26 lines

START DATABASE samples;

CLEAR
? "Simple Retrievel:"
SELECT fname, lname
FROM emp;

WAIT
CLEAR
? "Retrieval with Selection and Order:"
SELECT lname,address
FROM emp
WHERE lname > "M"
ORDER BY lname;

WAIT
CLEAR
? "Joining of EMP and EMPRATE then Retrieval:"
SELECT fname,lname, emprate.rate
FROM emp,emprate
WHERE emp.empid=emprate.empid
ORDER BY lname;

WAIT
CLEAR